home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software Vault: The Gold Collection
/
Software Vault - The Gold Collection (American Databankers) (1993).ISO
/
cdr11
/
pdox693.zip
/
TI628.ASC
< prev
next >
Wrap
Text File
|
1992-11-12
|
5KB
|
199 lines
PRODUCT : Paradox, SQL Link NUMBER : 628
VERSION : 1.0 & up
OS : DOS
DATE : November 12, 1992 PAGE : 1/3
TITLE : Overview and abilities of Paradox SQL Link
Intended Audience:
Those persons interested in learning about the abilities of
Paradox SQL Link.
Prerequisites:
None
Purpose:
This Technical Information sheet provides an overview of the
abilities of Paradox SQL Link.
Paradox SQL Link is an add-in product that allows you to use
Paradox 4.0 (or 3.5) as a front end for accessing data from a SQL
database server. You can use Paradox's interactive menus or the
PAL language for accessing this information, without having to
learn SQL programming.
SQL (Structured Query Language) is an internationally established
database language for managing relational data. To use the data
the SQL language statements must be used. Paradox SQL Link
operates as a layer between Paradox and the SQL server,
translating a Paradox operation into the appropriate SQL commands
and then forwarding them to the server. The commands are then
executed and any result is returned to Paradox as a normal Answer
table. Paradox can simultaneously work with remote tables and
conventional Paradox tables.
SQL is usually implemented in a client-server architecture.
There is a database server (commonly a mainframe, mini or high-
end PC.) with clients (generally PC's) connected through a
network. Paradox is run on the PC workstations of the network.
Since the data is stored and directly manipulated on the central
server, having a powerful server machine can yield good
performance without high machine requirements for the client
workstations (80286 or higher CPU, RAM requirements below).
Using Paradox as the front end, allows access to larger amounts
of data without learning a new software package. Data security
and maintenance can also be simplified by having the data stored
on one central machine.
PRODUCT : Paradox, SQL Link NUMBER : 628
VERSION : 1.0 & up
OS : DOS
DATE : November 12, 1992 PAGE : 2/3
TITLE : Overview and abilities of Paradox SQL Link
The SQL servers currently supported are: RAM Req'd (MB)
Ver 3.5 Ver 4.0
DEC VAX Rdb/VMS 3.1B or higher*** 1.0 2.0
IBM Extended Edition Database Mgr. 1.2 or higher 1.0 2.0
Microsoft SQL Server 1.x or higher 1.0 2.0
Oracle Server 6.0 or higher 1.5 2.0
Sybase SQL Server 4.x or higher 1.0 2.0
DB2 (Through MDI Gateway) 1.0 2.0
Novell Netware SQL 3.0 * 2.0
Interbase * 2.0**
* Only available for SQL Link 4.0.
** Not yet available.
*** 4.0 or higher for Paradox 4.0
ABILITIES
Some of the capabilities of Paradox with SQL Link are:
1. Queries on database tables
a. For manipulating data on the server
b. Retrieving data from the server.
2. Table creation and access of existing tables.
3. Table manipulation (add, copy, delete, empty, etc.).
4. Reporting of information existing on the server.
5. Added PAL commands and functions for programming access to
the server.
6. Application of transaction processing techniques for data
integrity.
PRODUCT : Paradox, SQL Link NUMBER : 628
VERSION : 1.0 & up
OS : DOS
DATE : November 12, 1992 PAGE : 3/3
TITLE : Overview and abilities of Paradox SQL Link
REQUIREMENTS
The database server and appropriate network must be running. For
Paradox 3.5, the workstations must be running in protected mode
to utilize SQL Link. For additional information on protected
mode, refer to the Paradox 4.0 User's Guide, Chapter 23 -
Advanced Topics/"How Paradox manages memory" (for version 3.5,
refer to the User's Guide, Chapter 14 - Advanced Topics/"How
Paradox manages memory").
DISCLAIMER: You have the right to use this technical information
subject to the terms of the No-Nonsense License Statement that
you received with the Borland product to which this information
pertains.